# !/usr/bin/python
# -*- coding: UTF-8 -*-

import pandas as pd


def read():
    test_2 = pd.read_excel('HHT_BMS全部信号上传需求总表_toHiBS.xlsx', sheet_name=None)
    # 每个sheet分别保存为独立的csv，注意要用utf-8-sig格式
    for key in test_2:
        exec(
            "test_2[key].to_csv(\"{}.csv\",index=False,encoding=\'utf-8-sig\')"
            .format(key))


if __name__ == '__main__':
    read()
